1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class Kho_SpKiemKhoMod
15 {
16 protected int PageSize { get; set; }
17 protected int PageIndex { get; set; }
18
19 protected int IdKho_SpKiemKho { get; set; }
20 protected int IdKho_KiemKho { get; set; }
21 protected string IdKhoStr { get; set; }
22 protected string MaSanPham { get; set; }
23 protected float SoLuongTrongKho { get; set; }
24 protected float SoLuongKiemKho { get; set; }
25 protected string TrangThai { get; set; }
26 protected DateTime NgayTaoThucHien { get; set; }
27 protected int NhanVienId { get; set; }
28 protected string GhiChu { get; set; }
29
30 protected string TenSanPham { get; set; }
31 protected int DonViTinhId { get; set; }
32
33 public Kho_SpKiemKhoMod()
34 {
35 }
36
37 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho)
38 {
39 IdKho_SpKiemKho = _IdKho_SpKiemKho;
40 }
41
42 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho)
43 {
44 IdKho_SpKiemKho = _IdKho_SpKiemKho;
45 IdKho_KiemKho = _IdKho_KiemKho;
46 }
47
48 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr)
49 {
50 IdKho_SpKiemKho = _IdKho_SpKiemKho;
51 IdKho_KiemKho = _IdKho_KiemKho;
52 IdKhoStr = _IdKhoStr;
53 }
54
55 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _MaSanPham, string _TrangThai)
56 {
57 IdKho_SpKiemKho = _IdKho_SpKiemKho;
58 IdKho_KiemKho = _IdKho_KiemKho;
59 MaSanPham = _MaSanPham;
60 TrangThai = _TrangThai;
61 }
62
63 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho, int _PageSize, int _PageIndex)
64 {
65 IdKho_SpKiemKho = _IdKho_SpKiemKho;
66 IdKho_KiemKho = _IdKho_KiemKho;
67 PageSize = _PageSize;
68 PageIndex = _PageIndex;
69 }
70
71 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr, string _MaSanPham, float _SoLuongTrongKho, float _SoLuongKiemKho, string _TrangThai, DateTime _NgayTaoThucHien, int _NhanVienId, string _GhiChu, string _TenSanPham, int _DonViTinhId)
72 {
73 IdKho_SpKiemKho= _IdKho_SpKiemKho;
74 IdKho_KiemKho= _IdKho_KiemKho;
75 IdKhoStr = _IdKhoStr;
76 MaSanPham = _MaSanPham;
77 SoLuongTrongKho = _SoLuongTrongKho;
78 SoLuongKiemKho =_SoLuongKiemKho;
79 TrangThai = _TrangThai;
80 NgayTaoThucHien =_NgayTaoThucHien;
81 NhanVienId = _NhanVienId;
82 GhiChu =_GhiChu;
83 TenSanPham = _TenSanPham;
84 DonViTinhId = _DonViTinhId;
85 }
86
87 public Kho_SpKiemKhoMod(int _IdKho_SpKiemKho, int _IdKho_KiemKho, string _IdKhoStr, string _MaSanPham, float _SoLuongTrongKho, float _SoLuongKiemKho, string _TrangThai, DateTime _NgayTaoThucHien, int _NhanVienId, string _GhiChu, string _TenSanPham, int _DonViTinhId,int _PageSize, int _PageIndex)
88 {
89 IdKho_SpKiemKho = _IdKho_SpKiemKho;
90 IdKho_KiemKho = _IdKho_KiemKho;
91 IdKhoStr = _IdKhoStr;
92 MaSanPham = _MaSanPham;
93 SoLuongTrongKho = _SoLuongTrongKho;
94 SoLuongKiemKho = _SoLuongKiemKho;
95 TrangThai = _TrangThai;
96 NgayTaoThucHien = _NgayTaoThucHien;
97 NhanVienId = _NhanVienId;
98 GhiChu = _GhiChu;
99 TenSanPham = _TenSanPham;
100 DonViTinhId = _DonViTinhId;
101
102 PageSize = _PageSize;
103 PageIndex = _PageIndex;
104 }
105
106 public int InsertKho_SpKiemKho()
107 {
108 int i = 0;
109 string[] paras = new string[12] {"@IdKho_SpKiemKho", "@IdKho_KiemKho", "@IdKhoStr", "@MaSanPham", "@SoLuongTrongKho", "@SoLuongKiemKho", "@TrangThai", "@NgayTaoThucHien", "@NhanVienId", "@GhiChu", "@TenSanPham","@DonViTinhId" };
110 object[] values = new object[12] { IdKho_SpKiemKho, IdKho_KiemKho, IdKhoStr, MaSanPham, SoLuongTrongKho, SoLuongKiemKho, TrangThai, NgayTaoThucHien, NhanVienId, GhiChu ,TenSanPham,DonViTinhId};
111 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_Kho_SpKiemKho_Insert", CommandType.StoredProcedure, paras, values));
112 return i;
113 }
114
115 public int UpdateKho_SpKiemKho()
116 {
117 int i = 0;
118 string[] paras = new string[12] { "@IdKho_SpKiemKho", "@IdKho_KiemKho", "@IdKhoStr", "@MaSanPham", "@SoLuongTrongKho", "@SoLuongKiemKho", "@TrangThai", "@NgayTaoThucHien", "@NhanVienId", "@GhiChu", "@TenSanPham", "@DonViTinhId" };
119 object[] values = new object[12] { IdKho_SpKiemKho, IdKho_KiemKho, IdKhoStr, MaSanPham, SoLuongTrongKho, SoLuongKiemKho, TrangThai, NgayTaoThucHien, NhanVienId, GhiChu, TenSanPham, DonViTinhId };
120 i = Models.connection.Excute_Sql("tbl_Kho_SpKiemKho_Update", CommandType.StoredProcedure, paras, values);
121 return i;
122 }
123
124 public int DeleteKho_SpKiemKho()
125 {
126 int i = 0;
127 string[] paras = new string[1] { "@IdKho_SpKiemKho" };
128 object[] values = new object[1] { IdKho_SpKiemKho };
129 i = Models.connection.Excute_Sql("tbl_Kho_SpKiemKho_Delete", CommandType.StoredProcedure, paras, values);
130 return i;
131 }
132
133 //danh sach kiem kho
134 public DataSet FillDataSet_getKho_SpKiemKho_Search()
135 {
136 DataSet ds = new DataSet();
137 string[] paras = new string[14] { "@IdKho_SpKiemKho", "@IdKho_KiemKho", "@IdKhoStr", "@MaSanPham", "@SoLuongTrongKho", "@SoLuongKiemKho", "@TrangThai", "@NgayTaoThucHien", "@NhanVienId", "@GhiChu" , "@TenSanPham", "@DonViTinhId","@PageSize", "@PageIndex"};
138 object[] values = new object[14] { IdKho_SpKiemKho, IdKho_KiemKho, IdKhoStr, MaSanPham, SoLuongTrongKho, SoLuongKiemKho, TrangThai, NgayTaoThucHien, NhanVienId, GhiChu,TenSanPham,DonViTinhId,PageSize, PageIndex };
139 ds = Models.connection.FillDataSet("tbl_Kho_SpKiemKho_Search", CommandType.StoredProcedure, paras, values);
140 return ds;
141 }
142
143 //lay danh sach san pham trong kho theo ngay kiemkho
144 public DataSet FillDataSet_getKho_SpKiemKho_ByIdKhiemKho()
145 {
146 DataSet ds = new DataSet();
147 string[] paras = new string[4] { "@IdKho_SpKiemKho", "@IdKho_KiemKho", "@PageSize", "@PageIndex" };
148 object[] values = new object[4] { IdKho_SpKiemKho, IdKho_KiemKho, PageSize, PageIndex };
149 ds = Models.connection.FillDataSet("tbl_Kho_SpKiemKho_ByIdKhiemKho", CommandType.StoredProcedure, paras, values);
150 return ds;
151 }
152
153 //kiểm tra sản phẩm đã tồn tại trong kiem kho
154 public DataSet FillDataSet_getKho_SpKiemKho_KiemTraDaTonTai()
155 {
156 DataSet ds = new DataSet();
157 string[] paras = new string[4] { "@IdKho_SpKiemKho", "@IdKho_KiemKho", "@MaSanPham", "@TrangThai" };
158 object[] values = new object[4] { IdKho_SpKiemKho, IdKho_KiemKho, MaSanPham, TrangThai };
159 ds = Models.connection.FillDataSet("tbl_Kho_SpKiemKho_KiemTraDaTonTai", CommandType.StoredProcedure, paras, values);
160 return ds;
161 }
162
163 }
164 }